USE FITHOU_EDU
GO
SET dateformat dmy
go


INSERT INTO tbl_Nguoidung VALUES('SV08B601',N'Quang Van Liem','05/02/1990','Dinh Cong - Hoang Mai','0989320758','liemqv@gmail.com','123',1)
INSERT INTO tbl_Nguoidung VALUES('SV08B602',N'Bui Thanh Minh','01/11/1989','Dinh Cong - Hoang Mai','0989320777','buithanhminh.hou@gmail.com','123',1)

INSERT INTO tbl_Nguoidung VALUES('GV001',N'Nguyen Van A','05/02/1980','Dinh Cong - Hoang Mai','0989329696','gv1@fithou.edu.vn','123',2)
INSERT INTO tbl_Nguoidung VALUES('GV002',N'Nguyen Van B','06/02/1980','Dinh Cong - Hoang Mai','0989329456','gv2@fithou.edu.vn','123',2)
GO

INSERT INTO tbl_Phonghoc(sTenphong, iSoghe) VALUES('P21',60)
INSERT INTO tbl_Phonghoc(sTenphong, iSoghe) VALUES('P22',60)
INSERT INTO tbl_Phonghoc(sTenphong, iSoghe) VALUES('P51',120)
INSERT INTO tbl_Phonghoc(sTenphong, iSoghe) VALUES('P52',120)
GO

INSERT INTO tbl_Lophoc(sTenlop) VALUES('08B1')
INSERT INTO tbl_Lophoc(sTenlop) VALUES('08B2')
INSERT INTO tbl_Lophoc(sTenlop) VALUES('08B3')
INSERT INTO tbl_Lophoc(sTenlop) VALUES('08B4')
INSERT INTO tbl_Lophoc(sTenlop) VALUES('08B5')
INSERT INTO tbl_Lophoc(sTenlop) VALUES('08B6')
GO

INSERT INTO tbl_Monhoc(sTenmonhoc,iSoHoctrinh) VALUES('Java',4)
INSERT INTO tbl_Monhoc(sTenmonhoc,iSoHoctrinh) VALUES('LT Web',4)
INSERT INTO tbl_Monhoc(sTenmonhoc,iSoHoctrinh) VALUES('SQL',3)
INSERT INTO tbl_Monhoc(sTenmonhoc,iSoHoctrinh) VALUES('C++',4)
GO

SET dateformat dmy
go
INSERT INTO tbl_Lichhoc(dNgayhoc,sGiobatdau,sGioketthuc,iTrangthai,FK_iLophocID,FK_sGiangvienID,FK_iPhonghocID,FK_iMonhocID) VALUES(getdate(),'6h45','9h45',1,1,'GV001',1,1)
INSERT INTO tbl_Lichhoc(dNgayhoc,sGiobatdau,sGioketthuc,iTrangthai,FK_iLophocID,FK_sGiangvienID,FK_iPhonghocID,FK_iMonhocID) VALUES(getdate(),'9h10','11h30',1,1,'GV002',1,2)
INSERT INTO tbl_Lichhoc(dNgayhoc,sGiobatdau,sGioketthuc,iTrangthai,FK_iLophocID,FK_sGiangvienID,FK_iPhonghocID,FK_iMonhocID) VALUES(dateadd(day,2,getdate()),'6h45','9h45',1,1,'GV001',1,1)
INSERT INTO tbl_Lichhoc(dNgayhoc,sGiobatdau,sGioketthuc,iTrangthai,FK_iLophocID,FK_sGiangvienID,FK_iPhonghocID,FK_iMonhocID) VALUES(dateadd(day,2,getdate()),'9h10','11h30',1,1,'GV002',1,2)
GO
